SHEETNAME

Returns the name of a specified sheet in the current workbook.

Syntax

SHEETNAME(sheet_num)

sheet_num - the index number of the sheet (in the current workbook) to be considered. For example, the first sheet (count from the left) is 1, and so on.

Remarks

• You can specify a cell (cell reference) that contains a number, a logical values, or text representations of numbers. Cells that contain error values or text that cannot be translated into numbers cause errors.
• sheet_num must be larger than or equal to zero.
• If sheet_num is not a whole number, then it is rounded to the nearest integer.
• If sheet_num is 0 (zero), SHEETNAME returns the name of the current worksheet.
• If sheet_num is larger than the total number of sheets in the current workbook, SHEETNAME returns a #VALUE! error.

 

[ ©2000-2001, Edwin H. B. Tam, All rights reserved ]